ETL Testing Course Info : http://goo.gl/vJfmwK <br /> <br />ETL stands for Extract Transformation and Load, It collect the different source data from Heterogeneous System and Transform the data into Data warehouse. <br /> <br />At the Time of Transformation, Data will first transforms to the Staging Table. <br /> <br />Based on Business rules the data is mapped into target table, this process manually mapped and configured using ETL Tool <br /> <br />ETL will not transforms the Duplicate data <br /> <br />The speed of Data Transformation process will be based on the Source and Target Data ware House. <br /> <br />We need to consider the OLAP (Online Analytic Processing) Structure as Data warehouse Model <br /> <br />Source data consists of XML,Flat file. <br /> <br />We need to set the validation at time of data transformation like ‘Avoid the ‘NULL’ values in the table, <br /> <br />validate the data type as using Tiny int instead of integer .etc <br /> <br />Based on the user requirement, ETL process starts.
